<?php
namespace app\course\model;

use think\Model;

class User extends Model{

    public function SC($id){
        $data= $this->alias('s')
                    ->join('sc a','s.Id = a.S_Id')
                    ->join('course c','a.C_Id = c.Id')
                    ->where('s.Id',$id)
                    ->select();
        return $data;
    }

    public function TC($id){
        $data= $this->alias('t')
                    ->join('tc a','t.Id = a.t_Id')
                    ->join('course c','a.C_Id = c.Id')
                    ->where('t.Id',$id)
                    ->select();
        return $data;
    }
}